SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249383 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249383 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250710,960332,1012835,790718,903572,1020198,647782,791380,887438,666277,530592,279776,89586,750182,811655,44357,561330,281195,311222,796183,42940,489410,480330,208482,316490,250886,160951,704269,858354,821220,426872,416010,671511,161933,514654,64057,430700,719579,1009244,1036354,867532,876712,638081,531494,74334,416739,600193,598281,611237,732987,898010,438564,379482,827558,462078,681025,928163,422563,475843,507404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]