SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504050 LIMIT 1 [ RunTime:0.003200s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504050 [ RunTime:0.003878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582633,221279,53731,173787,1044445,182568,233052,659824,371722,434597,32362,782031,589650,539612,855342,654984,915087,172409,356274,167183,810323,119980,168044,599325,176383,398695,553821,489314,675073,936791,589016,494594,602046,503095,916711,374102,805925,347813,112697,155913,149204,1027260,361621,678935,1042626,353790,182941,838344,440552,248628,666843,822985,721977,207761,831732,242802,960222,968515,262217,157493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]