SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015770 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015770 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64748,791178,903269,935846,137132,346646,92753,146002,165324,605737,597757,482217,582077,693706,887353,978444,475121,467714,895303,482800,510533,426375,158123,600405,380595,474079,952537,694282,239207,188477,903125,96248,1039586,1019949,772025,685343,172156,82718,64352,303374,350715,802766,549543,842373,683541,969419,530779,839336,920118,472249,263872,660191,717044,1042927,80913,26555,597634,849059,367022,658527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]