SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430518 LIMIT 1 [ RunTime:0.003858s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430518 [ RunTime:0.008886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873830,1009175,814078,939435,983715,523079,517585,148669,321631,905598,582337,275608,961422,69459,995254,667125,856065,443541,536857,875596,496308,332940,352472,566998,229708,736488,1041677,310034,869475,615984,502659,545466,4765,255626,645700,485705,792212,807832,733838,1002613,78321,6550,792763,319172,144159,554457,1001267,712219,222223,705534,78414,593951,1048454,900546,957455,349512,399757,1040624,573331,49382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001298s ]