SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381010 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381010 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892164,549012,776511,945984,411393,79465,238792,831192,403724,326223,886859,99190,117030,820287,531282,336217,1006813,930955,22837,765592,380798,307138,817639,667118,634985,526753,407351,143074,976993,422284,700529,751226,764105,696188,287197,935639,702961,745533,183878,878043,227369,342568,218113,171526,924836,74896,781766,965053,510524,22789,90796,529860,539794,278690,627443,973080,1026439,257627,657341,186822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]