SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974605 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974605 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913251,629176,104088,617315,606897,595818,174842,527002,201300,865727,653987,551294,1029785,575387,586311,335413,273700,687033,168550,512017,443010,568705,346423,952094,259503,905658,702782,569471,926174,515651,674094,943745,530663,232094,351673,697185,226618,957828,979650,246134,252634,667689,301364,620633,353207,1041044,33355,885420,531043,782723,355389,803607,348949,616741,371513,97163,421180,761805,726161,791681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]