SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530222 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530222 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580647,857686,29035,326200,999112,862006,508066,607705,387426,545267,886908,113803,884112,567800,1005356,566118,992643,43805,1034639,937907,439113,996862,158182,231458,129248,693681,479243,84503,317419,594296,170392,481087,308509,483334,635100,1046142,95520,408020,1025679,457084,542252,38284,169202,407213,88481,476421,811958,472497,440771,343689,801475,545338,743408,189029,75678,686808,646936,623064,399819,119253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]