SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406384 LIMIT 1 [ RunTime:0.001646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406384 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514596,706268,808842,449612,351348,26373,293174,693022,59142,518355,73737,57158,637187,428892,120507,45394,586601,312681,612148,497686,833171,531636,88960,772351,242049,527954,312740,113702,327683,724777,546546,155882,500661,441048,809248,387079,282493,409118,809871,394005,8206,445966,771852,382576,62984,918225,95574,21826,248445,310785,195550,197302,1039333,583779,86578,467324,802285,917634,853972,480152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]