SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 938310 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 938310 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992074,614443,403343,452309,1007425,414700,473846,542862,662124,89959,747998,1010937,394232,510442,54484,388732,663120,904507,845798,187515,1020146,740788,472548,833187,878601,123871,272484,171512,992671,722350,53297,159818,700714,823815,211396,185105,858778,549246,514879,203497,171678,464109,826873,261074,237753,752347,572719,969292,357661,337234,61195,1030011,925884,1043816,104446,989450,1007674,27709,507529,158841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 938310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 938310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]