SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598716 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598716 [ RunTime:0.002724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251518,821068,223339,561329,119722,792356,397898,823568,389169,190054,604034,683254,352503,567682,86503,961082,285403,1047806,14329,27454,812047,550555,29404,263091,389013,395643,471567,576184,372660,283520,791230,984534,900795,88318,998698,454982,618108,970124,597187,635514,794271,940415,651060,376498,361153,743173,727474,145148,723062,769218,992824,129658,418572,113687,581180,279652,823674,106557,343584,631660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]