SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 246414 LIMIT 1 [ RunTime:0.000546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 246414 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750985,880950,360052,418409,201658,853972,864204,272432,997523,644372,137723,1020291,983962,528625,1013883,532180,1028332,472449,92672,701352,739831,860795,318778,1041389,1012160,1039915,204176,339677,313182,636600,686767,848443,977734,692045,406749,595677,497524,114939,198857,656018,202764,779493,610994,448875,537994,738467,762728,264444,500508,455731,242609,492512,104785,462217,369215,142401,570011,457246,730530,583114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 246414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 246414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]