SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 137104 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 137104 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014056,1023686,62475,754617,633960,1021842,660432,399815,640051,146390,835418,22177,37342,744549,701126,154250,736759,559538,325506,510680,724715,805770,140007,468684,758344,48758,53966,845892,74144,1035547,438769,634269,212854,146014,898903,384908,891951,343654,947682,495444,15224,77473,20170,91248,749443,87451,538741,503485,183314,595596,587174,956886,73153,716483,933340,672803,873490,998626,579528,310028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 137104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 137104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]