SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037271 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037271 [ RunTime:0.002393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4639,19234,3403,796586,984601,435136,457693,732088,994229,5283,704516,442557,956543,564398,77660,31049,27133,131234,305566,294324,788715,104222,349925,383561,921813,868592,1045854,241469,610431,308153,235539,795851,312906,752288,862613,534667,312645,818420,789722,45645,146842,749517,510843,583630,739413,639690,837064,567397,961787,578476,988164,467893,159261,315529,389557,580081,531866,302384,99037,189796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]