SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010616 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010616 [ RunTime:0.005584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351775,676151,612067,880142,576908,30213,699474,787479,431552,1041904,275277,614490,305234,150867,296909,571310,331144,142655,554731,962409,1015883,127213,622736,784884,790358,68083,25510,961747,960282,430172,586027,34409,544736,406580,906128,772026,209773,240775,11215,395096,682080,1007174,25432,896002,570732,154085,526100,90319,513668,586500,196514,611444,674915,415543,141405,93945,358025,930947,3072,572799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]