SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503643 LIMIT 1 [ RunTime:0.000636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503643 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443102,944410,602731,124025,250003,306191,476911,627019,116994,713790,849376,841475,884309,887505,252941,70629,922994,233462,184802,908586,890638,97983,334665,1002348,761335,210159,388444,971032,593950,896499,684423,613940,460182,11060,161850,123611,242681,150109,907955,634532,602471,461052,618190,538186,305178,702534,861593,921345,448446,336938,639063,312629,615067,707702,711478,576919,850977,429201,820265,171309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001888s ]