SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199908 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199908 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369732,991094,848797,181704,511750,563664,591236,730720,886926,775796,769717,469622,126415,359089,162196,69534,325427,338904,110928,1008693,698061,17604,308947,999139,434528,572632,788781,1021046,429243,241197,527237,552959,971135,213499,381953,766932,269520,119626,202690,848792,407601,536107,468124,212651,240405,213336,896145,1019293,777325,876535,59893,372833,329498,385928,554972,909077,691710,582451,515447,545064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]