SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401515 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401515 [ RunTime:0.004280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529979,1034364,103503,382943,822923,121697,1028997,803642,991224,586705,798084,804164,76580,226772,146596,139067,891912,1037846,297616,775234,80521,957784,319207,118217,266114,349792,549514,563080,867519,352822,429311,417904,364889,778985,386420,448587,916534,585388,410127,816738,739358,602942,496110,31264,306011,693178,932079,270242,643623,504153,35968,413110,1017771,930718,722591,768091,339754,883902,508957,82534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]