SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443410 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443410 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951267,272083,299902,692158,689694,1021719,811507,704939,27006,141404,188661,770524,91946,352825,598408,685584,57815,47511,870604,346702,594941,438921,846241,903788,572699,670202,481654,321823,107612,28619,531080,61687,209913,416927,692196,326834,225920,211362,544504,657827,2373,963587,888070,250763,341873,6778,360133,852833,837913,549140,763433,305332,520266,262746,430638,968877,144732,144500,671892,161635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]