SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436505 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436505 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131718,609154,648221,972784,841161,987144,315805,1006151,528976,394789,521778,488494,746287,42798,146122,808896,240873,692935,401659,40974,402803,117879,840078,464894,217724,312339,769455,52057,768934,535298,1047098,699481,735783,523559,339736,700347,17930,192736,412466,126458,981070,510556,644557,282354,838577,61452,747575,31182,9323,813339,41400,818417,945203,456283,309917,90330,280926,806150,738194,661565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]