SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505743 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505743 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700398,804640,75770,640149,670580,593450,713163,733142,741106,22470,416870,515642,115680,192518,439494,76840,829773,133088,107711,986055,217829,822183,389549,913917,691079,767896,1027017,1019249,1024252,943380,714583,269864,100681,192212,241475,973802,493260,380483,853633,866465,901941,1007048,699880,833043,598909,410300,634131,475555,967945,193141,288821,92782,352723,707803,512809,306101,961077,330814,121408,584751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]