SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939611 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939611 [ RunTime:0.003213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865259,1000407,886795,1047773,530288,973144,809576,162424,507749,423891,1011214,358781,484448,30180,283322,484270,296924,899384,1017482,92673,869464,215145,768765,823365,158033,362996,47987,1026314,498102,81622,765762,148616,202834,393423,602444,95168,504349,851304,592024,639762,638783,617654,743709,832173,406397,352903,1014573,832871,14720,1023612,246498,962528,579618,650274,493018,454924,546589,790080,3256,99854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]