SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046534 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046534 [ RunTime:0.003486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796446,642599,89010,811960,953387,503731,201514,1032290,950449,198834,602092,131638,491139,933408,108672,242697,691967,625288,161947,180452,663529,755111,561717,543056,845059,426198,244026,231045,480836,712075,989244,720222,41516,367983,518385,23298,336010,371629,515311,79792,515290,577732,643066,700077,412765,749805,560710,303530,716080,557470,247266,836705,373413,774224,16086,1934,400648,831388,491195,562748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001375s ]