SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 894083 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 894083 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171988,953150,404609,1021149,1040343,434119,550508,303381,922209,913789,739658,377804,169384,959104,267257,892336,347985,513418,364433,533866,155275,254796,941702,428600,652040,998344,263540,530566,152399,453511,1036194,814276,214106,122957,633223,918294,15881,520779,1036272,1007247,835646,338667,923924,295839,199132,140070,670946,134154,887547,261989,767950,663617,811842,765699,283829,234181,237744,863545,1044566,879098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 894083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 894083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]