SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539608 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539608 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260531,1036584,175042,170872,146543,543970,995185,263227,752485,500878,634018,393029,6257,904059,316261,74312,119984,849384,876964,464276,374239,398010,68670,408963,338626,663523,595829,598994,934216,678887,755890,956804,509191,897594,924929,622098,856624,731009,451158,213687,634275,138180,256572,190117,542581,562103,618244,794053,956078,175491,890679,601181,759845,981152,1030824,189309,501068,580077,681789,651349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]