SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585803 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585803 [ RunTime:0.002950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235359,661845,871724,632174,788250,1048180,686944,618526,100264,779619,669143,436261,702273,208453,661857,852948,33045,827702,849064,376168,473219,585377,897169,228068,459553,583331,210283,41217,970143,416312,57895,428347,13531,30611,1497,152407,494685,274124,567184,89523,864877,358821,696001,318686,308308,808012,343768,26760,716540,430930,1027478,395206,124967,815083,96695,804338,992397,572690,98345,853043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]