SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803831 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803831 [ RunTime:0.003012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563745,489997,606083,720062,1004015,977483,183235,1040795,832672,208865,942448,165868,513987,809811,95904,460460,181044,73681,400967,399809,268759,693552,334264,673011,663906,171647,542781,565848,512101,22778,323898,356617,1006179,438335,347680,94808,1033839,13803,1001291,461942,996961,371753,23759,12796,12398,626877,187896,854353,972254,1023522,285025,602313,442431,1031911,664350,507589,125651,279359,542567,359423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]