SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534064 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534064 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690685,874772,727326,353726,415654,391602,404633,963164,413628,32234,822116,749912,1021098,560656,239218,297916,85539,278541,931855,822136,67923,371566,595739,449304,710429,218645,361511,1014723,252316,1032482,418771,432419,383138,451281,726636,81011,53862,201880,992394,499526,986776,968970,239296,390404,242123,834706,480283,72891,798245,122194,776041,418826,26158,406781,744025,902513,600006,227271,170154,1042081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]