SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315398,724874,1044081,587883,231464,300575,134327,565452,150418,435847,156683,356206,906806,64675,575786,875540,939120,936756,114988,788342,392661,423690,453177,457937,561162,354074,328565,612141,1004181,197689,819698,975136,697890,83256,160352,870322,719941,832549,45111,388995,858543,362995,111809,941133,422694,812779,773743,67613,376569,830899,759564,701588,666060,984566,474043,390671,425113,139113,493918,270723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]