SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570731 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570731 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023092,876779,442953,63917,325711,287779,473921,978284,58268,420109,313076,638172,796919,653541,585629,407514,19406,141489,604339,1006910,173197,575532,257095,123099,221986,485138,824086,248759,695752,920579,55004,318331,841110,681276,992301,706180,457361,393786,952085,136732,625408,12549,185087,296786,161327,985560,436318,641461,747455,909388,360687,165268,283407,662616,985644,748328,844870,486190,538038,472071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]