SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013186 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013186 [ RunTime:0.003888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480130,19147,1024367,1031951,607881,536245,873651,667437,297988,244276,439798,412279,394872,190327,545799,352246,226951,350535,15334,87532,821519,233918,176556,855422,128093,961384,251948,336064,850,572758,516030,665567,888042,805596,692547,939301,732190,158110,45591,71514,875765,535790,677220,163935,675709,872677,329187,924661,827473,505920,215807,480088,56977,951846,397533,283896,829547,459895,886829,371842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]