SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44433 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44433 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158463,701437,29157,736722,49780,442484,532057,1012912,785761,102798,1039425,784419,380500,41384,300635,631680,501145,124229,298340,884884,792836,751204,756479,220659,877033,331144,734729,650093,882475,237518,399028,56566,655603,693940,210173,30455,451180,308059,22812,722602,228654,894026,221435,677003,862470,492027,741557,427895,525378,1017804,1018485,349089,484543,931906,573284,505784,510181,493865,851498,847219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]