SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526490 LIMIT 1 [ RunTime:0.003443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526490 [ RunTime:0.003065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812167,938749,962039,750201,116592,424106,741984,1025291,179526,37886,4736,554369,684685,275164,25288,263544,358003,833651,882850,466514,91886,846917,331756,1043431,87366,917692,7956,647520,955128,402884,416411,715472,595760,876781,155740,156212,1035982,622204,178910,937207,762201,146154,497796,924537,558812,1022244,896156,28194,583528,509979,285971,576203,898861,105046,39002,215604,689824,954342,1038399,989301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]