SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540193 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540193 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650695,179745,130067,468766,141839,610143,408840,992597,1009456,185100,123138,955032,444735,1032300,509226,709635,323982,726515,407051,869604,974022,225898,688537,192608,965119,430154,965313,817009,73512,390880,453934,96806,882750,282491,411010,729521,672672,759483,123822,264293,769364,569229,808224,689213,109788,628217,575353,1029441,1012033,37850,198295,329357,1044635,362343,10381,122765,259198,340035,38588,543214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]