SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011814 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011814 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310289,416227,769106,102346,565016,820712,847486,877232,168552,941992,165574,794372,60125,540589,246087,297304,358515,665642,694727,427439,438870,276822,571902,223437,478843,821658,992308,467311,1030838,318652,899297,837785,439621,926040,479268,232376,229300,255135,827072,808573,1014984,690078,915630,954759,661309,364370,833378,656145,359457,954777,523018,104250,162547,297679,106164,910817,934460,1000041,430821,39196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]