SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975310 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975310 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403141,357802,1041820,205798,298757,338175,286304,875171,106739,93582,307356,422864,785128,293459,171958,248558,274724,868725,500640,198975,59634,945464,160916,121535,380869,353010,883667,737101,782528,878528,852578,937824,536070,875331,7218,336844,722275,981274,569497,124576,83456,51421,466065,263383,615101,462379,833909,349833,217885,82568,805120,56662,595824,506688,497500,602665,539854,38398,143211,399353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000981s ]