SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406124 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406124 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710914,518992,279348,915184,715899,1040586,320975,715805,1010130,696664,109923,163630,716903,411755,387355,632532,273940,182465,901033,176596,763701,988126,993002,712673,501542,416829,902661,399803,164971,394819,576624,127599,1023065,675298,425371,103115,1014316,147614,790666,435665,853356,832563,410810,959283,343295,338314,1002045,698696,1014160,848441,713944,980266,179956,335339,992930,428557,329469,408245,509133,102956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]