SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560413 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560413 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871004,327643,726587,922252,24296,912105,1048869,109126,317491,771245,444464,736420,732886,217958,178870,351266,34672,812226,207805,836774,362551,260530,443243,609550,867779,945971,633330,490810,896403,175488,636805,489564,375753,134210,866038,271691,716994,389588,751464,312708,650203,338470,344895,667930,537213,763087,413795,484640,990431,963715,478656,402966,1003581,591438,574697,142261,263106,166402,741384,420676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]