SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536017 LIMIT 1 [ RunTime:0.000724s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536017 [ RunTime:0.003617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435929,551047,124634,50049,216589,790581,936644,59134,240941,297334,580167,741270,826818,956203,487609,385287,272931,588775,124627,133544,901916,404607,634059,781576,857657,992218,734868,885473,764815,1043118,579097,737448,396076,275487,542597,345540,615122,134575,841899,522105,77075,1011028,942196,269432,500747,717035,380289,702812,325932,521484,544589,112225,488620,352859,738441,484149,636716,1010164,1011862,560204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]