SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406778 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406778 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181987,195033,118004,12308,466710,788985,335291,588531,733028,383253,315900,666910,870256,604343,649488,680311,333818,570918,960508,1016444,1043504,313581,281376,588450,345135,586465,43932,670171,956992,689290,866708,629895,963430,1031071,98140,803045,669752,451573,707353,185246,558179,630696,743597,681818,540318,118821,775504,53650,622637,149288,554558,357454,314536,364068,714537,567939,932096,132797,1017290,1017757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]