SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200901 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200901 [ RunTime:0.004304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932802,822489,836159,138923,309903,777084,199758,696843,89617,527629,1003719,125262,924319,919860,447481,861791,53180,947718,354321,154265,534451,481024,323474,742538,530880,689598,997605,964692,629428,331792,455635,925759,564987,804531,355399,170052,515073,744401,195203,824225,869338,140180,179293,724718,590623,682394,306793,792007,747742,68360,30840,576785,231495,759255,762763,272135,471952,860499,352914,474836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]