SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397654 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397654 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522017,501985,647136,635979,90231,633195,449685,608942,700671,357191,1014628,734605,977499,267107,243075,528107,789828,102859,829138,2319,802697,793417,1011207,963566,405680,403233,203536,770907,606190,774534,698144,864270,99318,526380,1009892,229536,933532,836349,779551,575948,1045359,927432,862032,138987,444277,593094,322549,580464,537151,929098,984091,735560,529421,330749,565367,295947,785865,22995,789233,478383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]