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` = 563691 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563691 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805615,987289,665906,775735,661183,992723,761760,824077,278201,20039,206380,454721,1012989,391244,417135,840443,406016,261949,345604,774583,150407,121886,971498,278821,608236,148254,267323,931053,396714,181177,796876,930163,919605,623973,935276,294902,405016,334375,675688,397700,650826,589463,244104,9427,723848,628064,65406,182619,523811,660216,500616,298937,511721,756417,981114,529040,1036227,6720,1010856,327526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]