SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452640 LIMIT 1 [ RunTime:0.000666s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452640 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212671,974355,422604,691048,642180,379708,192445,904633,942676,566307,544034,809627,168346,733167,526662,673555,707843,172557,330154,700963,612083,702072,822050,328230,568777,327933,662472,203043,413649,948038,137464,18649,653802,430895,948832,279185,476795,256684,111406,344297,580471,1029914,24558,49409,1015088,956881,168979,448673,103625,872705,798567,744659,863750,561150,683661,649047,576357,244146,973121,753171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001088s ]