SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029877 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029877 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462962,998371,288267,864231,173209,364890,148095,270133,418679,1024349,436886,862923,25150,406859,139660,692063,77330,588947,595603,584771,292938,771892,157407,537890,448807,800297,1015836,443098,93456,28047,296534,257840,151535,633492,195188,1043803,669685,1031584,547450,843713,1043715,439158,906265,250295,650471,298804,627638,991199,120762,894994,354883,368775,685339,337505,416716,422228,151380,951387,400666,494903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029877 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029877 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]