SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 677328 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 677328 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803543,412157,611079,405076,1037529,762999,1042309,407159,854804,248012,305844,986154,734865,180630,970529,291402,314522,472460,704225,317737,456830,265918,1048581,326213,70535,121070,194982,150514,110740,642067,876949,357112,825405,754761,678265,427987,1045963,752248,818800,221348,85296,62322,623893,557073,524134,592144,508745,1044674,905626,930554,661635,890877,672763,238643,8813,112939,145147,913462,59417,502392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 677328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 677328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]