SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54341 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54341 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505287,867938,191134,4493,819942,700252,120786,351361,166994,642750,205878,28141,336555,551798,357957,587920,857366,555033,340102,192218,800065,251877,515112,832785,157721,113852,227200,312022,48118,143794,278162,13960,1015535,254833,612905,939489,483984,815032,1005368,150445,331940,967920,867681,109703,337022,991570,656972,155045,252830,311413,864578,621817,973528,438638,72192,987487,720606,872674,450610,482886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]