SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543148 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543148 [ RunTime:0.002850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329896,835146,351052,631234,900770,40214,547809,310007,613370,753631,146252,624091,925584,58662,565448,583229,506150,280762,1025412,50211,864345,302386,709716,1038726,858060,78690,319550,116419,428636,856162,612928,453431,368345,869855,355322,1022582,411062,470072,357617,940770,983980,225145,798403,157850,804066,892463,967587,300418,1008431,947099,256598,621996,687625,156683,843022,238103,694517,641824,80882,296623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]