SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028974 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028974 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42365,901473,1033594,500777,93774,471411,354829,374643,391875,100098,691561,76406,1010712,324656,358594,958051,73438,575508,821594,723683,368394,118864,12472,87184,962243,432346,360291,615878,479951,367002,491070,176396,1033002,648165,64847,921350,97824,963832,666261,644713,764215,353106,679299,874494,16727,816132,356974,222888,877002,299794,1008161,849051,490591,749002,40403,430752,60191,55773,686983,589328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]