SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019036 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019036 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224321,952477,446022,798370,772193,770677,941928,968513,931391,871150,277897,324752,51546,1041882,162547,983769,479349,270668,677708,652204,800165,34995,829216,38797,332067,981466,742798,279193,783217,403924,84177,312305,673563,122432,709563,955620,657510,691989,745818,578693,696653,231897,498046,335901,258003,632085,884109,352372,768749,42262,624320,805131,1026489,289172,563300,471492,179082,999506,565698,305937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]