SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527991 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527991 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372523,318100,964794,772536,263655,69646,724759,33188,757953,368506,212506,212358,846386,1045271,722625,700497,988899,986441,253523,632470,1006139,382956,213312,91101,253071,938049,635065,965417,948375,699883,762177,231563,338816,134426,495663,258569,183989,148299,50627,905788,408787,908594,189497,57701,555603,1033,422609,267792,407886,53035,535699,666519,337224,239131,248961,320990,658015,1006632,537308,53550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]