SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530047 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530047 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774479,643159,653843,107043,912412,610583,1018463,245100,930086,233979,647094,646480,890868,842687,148934,745504,571918,619422,89141,202882,423314,197769,230964,103249,366773,1032656,614300,4593,813742,429192,885714,227119,384973,926108,10596,120921,780904,729385,985250,988820,538862,170888,409781,261716,464301,244929,948741,270444,15531,543873,822525,764945,436905,845412,111108,991678,6937,813037,20872,118514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]