SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416381 LIMIT 1 [ RunTime:0.001227s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416381 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520414,487351,577983,46900,291897,252392,58696,958413,843115,577196,423636,297798,120362,753917,330225,371501,169192,174844,307467,734153,124110,560905,91527,293647,875349,563159,373058,565322,195682,766766,986111,702258,892918,740975,960188,755670,408059,286826,755702,325207,723716,792813,352260,314116,978518,418333,450979,445005,981657,552468,815992,725481,395806,875763,786638,414087,540787,232473,159709,798175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]