SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811040 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811040 [ RunTime:0.002980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280819,714803,975293,1030869,201784,711853,224223,195737,526411,614818,1024550,895787,210264,1035837,578605,363263,483101,1044030,578925,120415,569445,587148,823002,132211,86235,257517,652643,567868,794198,108621,800899,449503,240164,777168,739621,549195,161652,994906,456464,172461,872184,642105,1046372,212057,328714,147737,822064,70869,708647,570919,268740,956228,387621,654805,919173,725913,1034073,920356,521567,1044282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]