SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012405 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012405 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284515,1021463,938578,54556,901770,404517,422126,594857,1025785,54785,198892,464145,38821,967518,281101,667563,274436,162622,7676,114370,376954,712822,187552,908809,534517,502,681435,620763,724139,315230,528739,451903,659483,349331,195712,803390,685050,129019,826429,786552,116319,834849,841317,552088,475415,824328,680111,583799,911578,1027729,179307,325306,748421,442903,242232,176397,373911,605224,609853,159649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]