SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401361 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401361 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552971,872731,355278,186846,289983,728268,350218,415544,505664,861705,556999,1019209,667623,566802,306232,947383,1031814,804643,300829,201749,748108,56949,1020184,722865,447627,137340,728488,707411,415778,740302,55986,541351,656118,644616,242518,378986,751530,939716,831143,32091,982535,393825,585191,813505,85045,124474,24258,907295,459962,688244,413939,169483,443670,137107,538861,469334,877063,784681,721348,372013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401361 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401361 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]