SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489120 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489120 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428182,242142,564656,531299,37011,612934,200824,943027,334947,742358,799205,435197,374631,373498,545764,398034,918885,1025670,1021271,115143,562287,1188,845597,523479,396049,128119,848167,764300,650854,601915,588603,126394,635458,23840,543741,839097,43357,840263,528914,872534,534531,864929,18387,667916,895439,19235,749900,270403,565781,771703,1026392,493597,903943,821344,382849,650425,508952,739879,167545,244075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000906s ]