SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001259 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001259 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689969,101640,1034657,866142,60812,23526,243326,424039,733890,49442,295530,881848,628963,643156,993473,447941,225333,120798,690379,195363,778351,1047393,408983,194249,449611,157850,435699,192784,914397,678369,386343,801876,366021,198752,952914,746608,575219,615427,533987,914298,613877,537935,170998,180429,1034888,56842,941806,1014735,847480,886108,675430,434548,494597,751324,982868,843056,744500,568506,778574,1044838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]