SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291340 LIMIT 1 [ RunTime:0.002230s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291340 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40136,400454,692811,341226,238143,27695,417173,958296,211938,13591,814867,718371,943337,506126,491906,35629,907553,512615,209883,679634,443080,42876,953499,467107,40321,783788,185046,944039,389900,371580,575944,871953,918527,464601,916173,50513,827259,962138,608955,363725,918119,308894,633735,282817,346687,331112,1019352,610405,930692,836484,830981,33268,391604,445884,409722,547569,26138,520300,566706,251367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]