SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10561 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10561 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241822,359033,925691,403992,991072,478247,231646,59193,413353,799238,541324,567944,709603,606603,292673,321411,974054,486401,399409,19612,891469,780056,15573,31402,473438,200614,63543,371482,407038,541476,525511,652364,315194,642661,242069,929752,275480,778653,557121,464495,352896,24439,275608,905482,940356,82683,702277,664190,518344,154419,628567,971880,827794,505659,808341,810047,231462,598331,184129,310221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001069s ]