SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016940 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016940 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799897,846738,245110,672684,383217,1006694,86528,261327,362462,922575,802240,310416,70750,356364,1010860,85276,385112,1042556,968995,332007,957268,675632,780684,693251,637496,205713,932984,36752,724301,877021,270751,38277,981614,278459,919907,356788,933310,311018,1021789,204939,95355,290236,126308,664651,1015746,125615,1011001,97525,226939,895963,637049,377599,555014,298909,288916,698730,561447,919387,969230,887473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]