SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316054 LIMIT 1 [ RunTime:0.002345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316054 [ RunTime:0.006657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362107,734345,375641,770191,11134,338101,52659,10591,833372,691117,284657,537729,474834,6396,590835,921528,686423,147694,398332,439006,237651,325657,1040925,83201,484938,420164,954408,592547,826653,790096,289752,1014624,1019752,621150,749249,243865,773882,942447,741627,120857,908691,661668,709713,981176,706363,30219,545871,677529,945478,464190,498251,226629,466195,868883,300995,498983,521986,692333,432778,978889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]