SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580092 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580092 [ RunTime:0.003001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142169,245624,262600,797778,300893,598009,841821,510613,637457,916800,1010890,353516,662268,967944,984726,984965,174065,576986,32553,967160,351904,688027,695957,934105,572389,200356,360179,350787,664648,541802,268772,157293,420499,338598,627527,340049,131201,487545,214403,833873,343967,352970,728805,494258,263176,600074,962306,490909,642117,789693,990065,332892,440039,78005,1032161,466289,456037,97382,340115,45829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]