SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 276041 LIMIT 1 [ RunTime:0.001068s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 276041 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010299,618852,489345,307667,548897,212680,3671,1006216,64084,765245,537043,42518,900685,830786,688182,279500,86108,526338,502150,1036012,331898,218917,939349,86278,291629,916270,880962,538764,624130,401851,525164,366598,471668,178364,542796,437989,39457,204946,634930,570412,114278,231154,407421,565921,278083,862651,290596,697224,627814,711532,979783,154228,886276,430556,877257,719456,989125,462330,312621,840051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 276041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 276041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]