SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298504 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298504 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770820,754551,516449,97889,107764,608860,339175,583365,1001770,538823,376845,457611,360435,324541,826070,111422,393278,104341,494494,568284,379634,149421,687188,939274,143889,14052,189072,93161,836930,212740,44236,356646,32139,245535,1012645,299834,480933,853238,583780,782658,236055,413804,1028496,601741,891564,625257,955216,68410,636642,77688,84800,342867,460331,840416,639723,1006169,848315,442291,610592,1003532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]