SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49841 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49841 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90371,294984,675866,832159,689543,939355,929403,93704,498172,152833,77330,996319,694343,664161,510552,651736,64511,1015195,747818,165067,495950,1013793,283129,490632,818544,902051,758013,218715,568551,507890,119878,711307,276334,443999,192496,854625,840558,241254,271976,583740,160510,683695,993905,538120,514381,852612,593505,955030,77865,798280,937659,761268,672555,605573,971475,158569,908666,115980,334693,236628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]