SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006821 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006821 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041778,525208,766127,184492,612277,233603,637708,596528,113331,277053,194726,995896,260627,683405,885829,686146,594564,575862,842522,963111,1041825,764072,328982,740102,638155,395926,248917,976857,608938,615879,18784,633371,66885,1037639,501462,12124,262471,543114,168297,906451,1008496,273015,771831,612113,906430,370324,236120,691417,386971,979067,587993,937992,818832,55461,790953,646215,141790,18653,487397,612828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]