SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961262 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961262 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814739,557702,924871,71709,255591,362075,518990,163415,495809,448384,799699,33321,587085,1009613,1043883,101619,752323,407593,273845,536454,1032089,114160,120,631358,1021228,867917,1034661,113660,772012,128970,478330,792907,1033351,334939,199669,346721,1019988,776161,428560,757185,258517,574236,320974,210793,905258,803931,967434,578832,906698,216605,702850,909975,156049,38608,518660,280112,987335,410904,297528,992430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]