SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291064 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291064 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374897,1047493,802610,403857,753459,469434,420972,734737,658805,9088,674471,441392,201566,554572,336050,350854,257780,78047,666435,224547,302592,294970,903648,344360,894830,975022,1038886,467298,1034547,936611,1021022,384314,748436,1035937,933742,705845,184272,726332,271795,281531,406846,428098,600001,179385,870429,248802,584005,363145,399473,563109,28044,537355,1030955,852746,359454,434965,135077,516505,991075,87299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]