SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324160 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324160 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407947,397041,696800,81746,856839,361234,437599,635682,441530,651735,18729,364681,549339,957087,717106,209314,36617,147735,982266,486478,827173,424494,815989,499124,565242,177742,883268,262919,709710,338703,67705,907336,618845,379053,495437,490174,691835,1042835,471074,128412,491910,135888,614214,145114,440703,127255,972365,321737,908376,468283,93880,751376,756846,81398,80092,973081,872555,902941,607929,856438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]