SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501473 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501473 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24844,843487,105200,365233,172577,500871,517061,490219,756993,914371,240249,62867,923826,163115,892186,944123,433341,16948,358583,231934,35918,277935,835776,539170,271943,280656,260788,1001497,973238,892831,765189,294751,391716,96654,766541,304911,371430,798259,522460,906006,419836,488395,272444,382917,715421,640178,225287,120240,206120,904048,200196,922537,408269,620029,1039352,460624,620807,144031,191785,1047089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]