SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436528 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436528 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277045,425226,488743,635875,202637,439532,390728,707645,396526,640679,1025084,295115,653571,135052,272014,364413,836012,109711,227742,104967,343039,167446,586921,407630,317461,536286,352843,1002892,423347,468157,679184,1041435,220112,40584,835253,628902,163286,931775,955297,745793,791663,995164,919774,603948,999567,684155,89371,45919,336725,968317,875280,1002726,32774,864294,1019708,557394,286813,480709,233139,626564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]