SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563899 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563899 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161998,46518,736805,66023,543619,654256,691635,878762,1023719,823419,770341,502970,280830,771905,586293,386201,1019665,46684,599220,1042464,101058,851561,34268,11578,705927,280450,817447,125484,674880,929963,317746,714050,64120,177764,321467,730771,976556,966215,197264,257483,569989,873179,513891,851011,772252,808305,1001556,194906,144001,995238,603938,1007565,243888,917283,471567,216312,814730,842089,80048,218412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]