SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44006 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44006 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325205,792403,348344,853697,387582,448739,493513,413510,1018498,710597,89810,451573,142050,530814,785554,425172,350865,969665,511938,598364,339667,245532,388056,833344,977551,78281,879823,630147,473684,706882,268306,1045159,894802,775903,578698,467984,239055,695963,544183,648514,461062,849303,416321,695162,191961,1005723,1037408,804591,318299,60212,77709,233797,34404,1016122,111139,1011896,1000783,128555,994371,1037061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]