SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201933 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201933 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498847,1007906,692032,535567,798343,113648,756794,821133,139267,507546,254399,547788,922461,267075,1038547,382965,961848,653471,1020840,310676,1040022,850605,425029,236267,627334,847788,56047,592475,239989,692381,657179,643167,605206,520404,161440,46709,515529,134983,182340,838865,944824,915216,586661,528685,125697,846063,192436,584272,986587,725715,405821,965843,106238,769045,17556,114500,16791,1043477,315598,964155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]